import pymysql
from pyecharts.charts import Bar
from pyecharts import options
db = pymysql.connect(
    host="localhost",
    port=3306,
    user="root",
    database="crawlerdemo",
    password="wang6688",
    charset="utf8"
)

cursor = db.cursor()
sql = "select avg(job_sal),job_place from job group by job_place order by avg(job_sal) limit 5"

sal = []
city = []
try:
    cursor.execute(sql)
    res = cursor.fetchall()
    for row in res:
        sal.append(row[0])
        city.append(row[1])
except Exception as e:
    print(e)
    print("查询出问题了")

bar=Bar()
#添加x轴
bar.add_xaxis(city)

bar.add_yaxis("月薪水/元",sal)
bar.set_global_opts(title_opts=options.TitleOpts(title="平均工资最低的五个城市",subtitle="单位/元"))

bar.render("baravg.html")
cursor.close()
db.close()